Tabela LBeneficiaryContr

Definicja tabeli LBeneficiaryContr

Name

LBeneficiaryContr

Code

LBeneficiaryContr

Comment

PL: Polaczenie beneficjenta z umowa – informacje o statusie w umowie
EN: Link between beneficiary and contract – vip status in contract information


Lista kolumn tabeli LBeneficiaryContr

Name

Code

LBeneficiaryContrID

LBeneficiaryContrID

ContractID

ContractID

StartDT

StartDT

StopDT

StopDT

VIP

VIP

BeneficiaryID

BeneficiaryID


Kolumna LBeneficiaryContrID tabeli LBeneficiaryContr

Definicja kolumny LBeneficiaryContrID tabeli LBeneficiaryContr

Name

LBeneficiaryContrID

Code

LBeneficiaryContrID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractID tabeli LBeneficiaryContr

Definicja kolumny ContractID tabeli LBeneficiaryContr

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli LBeneficiaryContr

Definicja kolumny StartDT tabeli LBeneficiaryContr

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LBeneficiaryContr

Definicja kolumny StopDT tabeli LBeneficiaryContr

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna VIP tabeli LBeneficiaryContr

Definicja kolumny VIP tabeli LBeneficiaryContr

Name

VIP

Code

VIP

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna BeneficiaryID tabeli LBeneficiaryContr

Definicja kolumny BeneficiaryID tabeli LBeneficiaryContr

Name

BeneficiaryID

Code

BeneficiaryID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli LBeneficiaryContr

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LBeneficiaryContr

Definicja klucza Identifier_1 tabeli LBeneficiaryContr

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment